Timestamp

The data is taken from a 13-year range from 2008 to 2021, the last year where data was recorded from OECD.

Data source

The source used was data from Organisation for Economic Cooperation and Development (OECD). It contained data about imports and exports trade values of multiple countries, on top of various sectors of choice.

Link to the source , Globalisation -> Trade by Enterprise Characteristics -> ISIC rev4 -> TEC by partner zones and countries.

Metadata

Actions Performed

  1. Export the dataset as a CSV file.
  2. Load it in a data frame using pandas (Python library).
  3. Selected only the rows that were associated with the TOTAL sector, since we weren’t interested in any specific sector of those provided.
  4. Dropped not useful columns.
  5. Saved the data frame as a CSV file.
  6. Loaded it on Flourish as data of a ‘Connections Globe’.
  7. Matched the graph parameters to the columns. We used two filters: the first one as a drop-down menu that allows one to decide which connection flow to project; the second being the years, thus enabling the animation.
  8. Made small changes and corrections to make the visualization more appealing and suited to our project. These included modifications on the size and color of the arrows, the initial zoom-in and rotation, and size of the graph.
  9. Lastly we decided to limit to 100 the arrows to show at a time to avoid visual noise.